{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["REG","README"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"REG","index":0,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Desc","Code",null,"Option Buttons"]
["ACTIVE PATIENTS","REG000",null,3]
["Applied","REG001"]
["Permanent","REG002"]
["Temporary Resident < 16 days","REG003"]
["Temporary Resident 16 days to 3 months","REG004"]
["Transferred Out","REG005"]
["Immediately Necessary Treatment","REG006"]
["Emergency Treatment","REG007"]
["Child Health Surveillance","REG008"]
["Contraception","REG009"]
["Maternity","REG010"]
["Minor Surgery","REG011"]
["Private","REG012"]
["Referred","REG013"]
["Walk in Centre","REG014"]
["GP with Special Interest","REG015"]
["Minor Injury Clinic","REG016"]
["HMP Inmate","REG017"]
["Visitor (EC111)","REG018"]
["INCLUDE ALL","NONE"]

{"sheet":"README","index":1,"n_rows":58,"n_cols":6,"rows_kept":58,"cut":false,"hidden":false,"merged":[[48,1,51,7],[4,5,4,7],[5,5,5,7]]}
[]
[null,"Baby Immunisation Report"]
[null,"Last updated: 28/08/2018 - Version 1.0"]
[]
[null,"Aged <=","Start Date","End Date",null,"SELECT REGISTRATION STATUS"]
[null,6,"2018-08-20","2018-08-26",null,"ACTIVE PATIENTS"]
[]
[]
[]
[]
[]
[null,"1.  Define the patient age and/or Date Range to search on and registration status"]
[null,"2.  Click the compile button to start the automatic data extraction from Vision"]
[]
[null,"Note: "]
[null,"This workbook will only show the following child immunisations:"]
[null,"DTAPIPVHIBHB(6in1) , MENB, PNEUMO, ROTAVIRUS, HIBMENC, MMR, DTAPIPV(Pre-school Booster)"]
[null,"Only immunisations that are recorded with a Status of GIVEN are included in this report"]
[]
[null,"Age Only Imm' Report - IMMS Sheet"]
[null,"This will list all children in defined age group and show the date of each immunisation"]
[null,"A blank cell means that no immunisation has been recorded"]
[null,"This report has been setup to print"]
[null,"A list of all children due their first immunisation can be found here using :"]
[null,"• Age range <= 1. Once the report has compiled: Select 'Blanks' only in the column filter for the 1st stage"]
[null,"The childs contact name is taken from 'Contacts of…' which may be entered in Registration or Con Mgr"]
[]
[null,"Age & End Date only Imm' Report - IMMS Sheet"]
[null,"This report is similar to the Age Only report, except that it will list all immunisations given up to the End date period"]
[null,"Note: This may not be a complete list of all children in that age group, if the immunisation was not given or is after the end date"]
[]
[null,"Age & Date Range Imm' Report - IMMS Sheet"]
[null,"This report will only list patients with immunisations given in the date range period"]
[null,"Note: This may not be a complete list of all children in that age group, if the immunisation was not given or is outside the date range"]
[]
[null,"IMMS ANALYSIS"]
[null,"This includes the same data as the IMMS sheet, but shows:"]
[null," • the childs age when each immunisation was given "]
[null," • the interval between each immunisation (requires 2 valid dates)"]
[]
[null,"IMM_DATA"]
[null,"This is the raw data extracted from Vision that is used to compile the data on the IMMS and IMMS ANALYSIS sheets"]
[]
[null,"Note: All patients listed in this report can be put back into Vision using the System Utilities App "]
[]
[null,"Written by: Bradley Sieve"]
[]
[null,"Disclaimer"]
[null,"In using this Microsoft Excel report you hereby acknowledge that the software cannot be guaranteed error free and may also be subject to how data is being recorded by your practice, and further acknowledge that the existence of any such errors shall not make Vision responsible for any actions you carry out based on these results."]
[]
[]
[]
[null,"NOTE:"]
[null,"This will only work if Vision is on DLM485 or above."]
[null,"Excel 2010 - Please \"Enable Content\" if a security Warning is displayed"]
[]
[null,"Excel 2007 - Click the Options button and Enable both Macros and Data Connection"]
[null,"Excel 2003 - Not Supported"]